Discrete List Text Parameter

Discrete list text parameters allow users to build parameters based on a discrete list of static text values. The parameter is then used to build custom formulas, custom lists, and variable lists, where dynamic elements are connected to the parameter's static text values.

A powerful way to use this feature is to write PQL or MDX text values, allowing users to build custom business logic based on code injected from a parameter.

Discrete list text parameters may be build as both model parameters and global parameters.

Configure a Discrete List Text Parameter

Define the discrete list from the Members panel. Click the blue plus sign to add as many parameter members as necessary. To remove a parameter member, click the x next to it.

For each parameter member, add a value and caption. The value is the text value of the specified parameter member. The caption is the label that will be assigned to the value in the resulting parameter slicer.

Click here for instructions on how to build a discrete list model text parameter. For details about creating a discrete list global text parameter, click here.

Using Discrete List Text Parameters

Once the discrete list text parameter has been saved, it can only be used by adding it to custom logic. It can be used to build:

  • Custom formulas using the Textual Parameter node
    • Add the Textual Parameter node to the canvas
    • From the Select Elements panel, navigate through the folder tree to find and select the required parameter
  • Custom lists using the Switch node
    • Add the Switch node to the canvas
    • In the Arguments panel click the folder icon
    • From the folder tree find and select the required parameter - both discrete list text parameters and numeric parameters will appear
  • Variable lists in Discover
    • From the Choose Variable panel, find and select the parameter from the folder tree - both discrete list text parameters and numeric parameters will appear

Custom logic built using the parameter can then be added to queries in Discover, Present, and Publish.